﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsShortPlan" targetNamespace="http://tempuri.org/dsShortPlan.xsd" xmlns:mstns="http://tempuri.org/dsShortPlan.xsd" xmlns="http://tempuri.org/dsShortPlan.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="tadUpdateRank" GeneratorFunctionsComponentClassName="tadUpdateRank" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="tadUpdateRank" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblVesselTableAdapter" GeneratorDataComponentClassName="tblVesselTableAdapter" Name="tblVessel" UserDataComponentName="tblVesselTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblVessel] WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_cVesselManaged = 1 AND [cVesselManaged] IS NULL) OR ([cVesselManaged] = @Original_cVesselManaged)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselManaged" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblVessel] ([nEngineType], [nEngineMaker], [fHorsePower], [cVesselName], [cShortName], [cVesselManaged], [nGroupId], [nFlagId], [nVesselTypeId], [fGRT], [cTradeArea], [cImoNumber], [cPortOfRegistry], [dYearBuilt]) VALUES (@nEngineType, @nEngineMaker, @fHorsePower, @cVesselName, @cShortName, @cVesselManaged, @nGroupId, @nFlagId, @nVesselTypeId, @fGRT, @cTradeArea, @cImoNumber, @cPortOfRegistry, @dYearBuilt);
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, cVesselManaged, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt FROM tblVessel WHERE (nVesselId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, cVesselManaged, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, 
                         cImoNumber, cPortOfRegistry, dYearBuilt
FROM            tblVessel
WHERE        (cVesselManaged = 'Managed')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblVessel] SET [nEngineType] = @nEngineType, [nEngineMaker] = @nEngineMaker, [fHorsePower] = @fHorsePower, [cVesselName] = @cVesselName, [cShortName] = @cShortName, [cVesselManaged] = @cVesselManaged, [nGroupId] = @nGroupId, [nFlagId] = @nFlagId, [nVesselTypeId] = @nVesselTypeId, [fGRT] = @fGRT, [cTradeArea] = @cTradeArea, [cImoNumber] = @cImoNumber, [cPortOfRegistry] = @cPortOfRegistry, [dYearBuilt] = @dYearBuilt WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_cVesselManaged = 1 AND [cVesselManaged] IS NULL) OR ([cVesselManaged] = @Original_cVesselManaged)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)));
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, cVesselManaged, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt FROM tblVessel WHERE (nVesselId = @nVesselId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselManaged" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nVesselId" ColumnName="nVesselId" DataSourceName="CrewManagment.dbo.tblVessel" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
              <Mapping SourceColumn="cShortName" DataSetColumn="cShortName" />
              <Mapping SourceColumn="nGroupId" DataSetColumn="nGroupId" />
              <Mapping SourceColumn="nFlagId" DataSetColumn="nFlagId" />
              <Mapping SourceColumn="nVesselTypeId" DataSetColumn="nVesselTypeId" />
              <Mapping SourceColumn="fGRT" DataSetColumn="fGRT" />
              <Mapping SourceColumn="cTradeArea" DataSetColumn="cTradeArea" />
              <Mapping SourceColumn="cImoNumber" DataSetColumn="cImoNumber" />
              <Mapping SourceColumn="cPortOfRegistry" DataSetColumn="cPortOfRegistry" />
              <Mapping SourceColumn="dYearBuilt" DataSetColumn="dYearBuilt" />
              <Mapping SourceColumn="nEngineType" DataSetColumn="nEngineType" />
              <Mapping SourceColumn="nEngineMaker" DataSetColumn="nEngineMaker" />
              <Mapping SourceColumn="fHorsePower" DataSetColumn="fHorsePower" />
              <Mapping SourceColumn="cVesselManaged" DataSetColumn="cVesselManaged" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByGroup" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByGroup" GeneratorSourceName="FillByGroup" GetMethodModifier="Public" GetMethodName="GetDataByGroup" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByGroup" UserSourceName="FillByGroup">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT cImoNumber, cPortOfRegistry, cShortName, cTradeArea, cVesselManaged, cVesselName, dYearBuilt, fGRT, fHorsePower, nEngineMaker, nEngineType, nFlagId, nGroupId, nVesselId, nVesselTypeId FROM tblVessel WHERE (nGroupId = @nGroupId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nGroupId" ColumnName="nGroupId" DataSourceName="CrewManagment.dbo.tblVessel" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblVesselGroupTableAdapter" GeneratorDataComponentClassName="tblVesselGroupTableAdapter" Name="tblVesselGroup" UserDataComponentName="tblVesselGroupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVesselGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblVesselGroup] WHERE (([nGroupId] = @Original_nGroupId) AND ((@IsNull_cGroupName = 1 AND [cGroupName] IS NULL) OR ([cGroupName] = @Original_cGroupName)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cGroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblVesselGroup] ([cGroupName], [cDescription]) VALUES (@cGroupName, @cDescription);
SELECT nGroupId, cGroupName, cDescription FROM tblVesselGroup WHERE (nGroupId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nGroupId, cGroupName, cDescription FROM dbo.tblVesselGroup</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblVesselGroup] SET [cGroupName] = @cGroupName, [cDescription] = @cDescription WHERE (([nGroupId] = @Original_nGroupId) AND ((@IsNull_cGroupName = 1 AND [cGroupName] IS NULL) OR ([cGroupName] = @Original_cGroupName)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)));
SELECT nGroupId, cGroupName, cDescription FROM tblVesselGroup WHERE (nGroupId = @nGroupId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cGroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nGroupId" ColumnName="nGroupId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nGroupId" DataSetColumn="nGroupId" />
              <Mapping SourceColumn="cGroupName" DataSetColumn="cGroupName" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblShortPlanTableAdapter" GeneratorDataComponentClassName="tblShortPlanTableAdapter" Name="tblShortPlan" UserDataComponentName="tblShortPlanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblShortPlan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblShortPlan] WHERE (([ID] = @Original_ID) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)) AND ((@IsNull_VesselID = 1 AND [VesselID] IS NULL) OR ([VesselID] = @Original_VesselID)) AND ((@IsNull_nCrewID = 1 AND [nCrewID] IS NULL) OR ([nCrewID] = @Original_nCrewID)) AND ((@IsNull_dEmbarkedDate = 1 AND [dEmbarkedDate] IS NULL) OR ([dEmbarkedDate] = @Original_dEmbarkedDate)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_DurationOnboard = 1 AND [DurationOnboard] IS NULL) OR ([DurationOnboard] = @Original_DurationOnboard)) AND ((@IsNull_nCrewIDNext = 1 AND [nCrewIDNext] IS NULL) OR ([nCrewIDNext] = @Original_nCrewIDNext)) AND ((@IsNull_TGHopDong = 1 AND [TGHopDong] IS NULL) OR ([TGHopDong] = @Original_TGHopDong)) AND ((@IsNull_TGDuKienLenTau = 1 AND [TGDuKienLenTau] IS NULL) OR ([TGDuKienLenTau] = @Original_TGDuKienLenTau)) AND ((@IsNull_TGDuKienRoiTau = 1 AND [TGDuKienRoiTau] IS NULL) OR ([TGDuKienRoiTau] = @Original_TGDuKienRoiTau)) AND ((@IsNull_isDone = 1 AND [isDone] IS NULL) OR ([isDone] = @Original_isDone)) AND ((@IsNull_NgayTTXuongTau = 1 AND [NgayTTXuongTau] IS NULL) OR ([NgayTTXuongTau] = @Original_NgayTTXuongTau)) AND ((@IsNull_NgayTTLenTau = 1 AND [NgayTTLenTau] IS NULL) OR ([NgayTTLenTau] = @Original_NgayTTLenTau)) AND ((@IsNull_NgayDuKienThayTV = 1 AND [NgayDuKienThayTV] IS NULL) OR ([NgayDuKienThayTV] = @Original_NgayDuKienThayTV)) AND ((@IsNull_nGhiChu = 1 AND [nGhiChu] IS NULL) OR ([nGhiChu] = @Original_nGhiChu)) AND ((@IsNull_NoiLen = 1 AND [NoiLen] IS NULL) OR ([NoiLen] = @Original_NoiLen)) AND ((@IsNull_NoiXuong = 1 AND [NoiXuong] IS NULL) OR ([NoiXuong] = @Original_NoiXuong)) AND ((@IsNull_NgayLenTau = 1 AND [NgayLenTau] IS NULL) OR ([NgayLenTau] = @Original_NgayLenTau)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarkedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dEmbarkedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DurationOnboard" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DurationOnboard" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewIDNext" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewIDNext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TGHopDong" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGDuKienLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_TGDuKienLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_TGDuKienRoiTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTTXuongTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayTTXuongTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTTLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayTTLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayDuKienThayTV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayDuKienThayTV" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NoiLen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NoiLen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NoiXuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblShortPlan] ([PlanID], [VesselID], [nCrewID], [dEmbarkedDate], [nContract], [DurationOnboard], [nCrewIDNext], [TGHopDong], [TGDuKienLenTau], [TGDuKienRoiTau], [isDone], [NgayTTXuongTau], [NgayTTLenTau], [NgayDuKienThayTV], [nGhiChu], [NoiLen], [NoiXuong], [NgayLenTau]) VALUES (@PlanID, @VesselID, @nCrewID, @dEmbarkedDate, @nContract, @DurationOnboard, @nCrewIDNext, @TGHopDong, @TGDuKienLenTau, @TGDuKienRoiTau, @isDone, @NgayTTXuongTau, @NgayTTLenTau, @NgayDuKienThayTV, @nGhiChu, @NoiLen, @NoiXuong, @NgayLenTau);
SELECT ID, PlanID, VesselID, nCrewID, dEmbarkedDate, nContract, DurationOnboard, nCrewIDNext, TGHopDong, TGDuKienLenTau, TGDuKienRoiTau, isDone, NgayTTXuongTau, NgayTTLenTau, NgayDuKienThayTV, nGhiChu, NoiLen, NoiXuong, NgayLenTau FROM tblShortPlan WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dEmbarkedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DurationOnboard" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewIDNext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TGHopDong" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@TGDuKienLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@TGDuKienRoiTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayTTXuongTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayTTLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayDuKienThayTV" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoiLen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, PlanID, VesselID, nCrewID, dEmbarkedDate, nContract, DurationOnboard, nCrewIDNext, TGHopDong, TGDuKienLenTau, TGDuKienRoiTau, isDone, 
                         NgayTTXuongTau, NgayTTLenTau, NgayDuKienThayTV, nGhiChu, NoiLen, NoiXuong, NgayLenTau
FROM            tblShortPlan</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblShortPlan] SET [PlanID] = @PlanID, [VesselID] = @VesselID, [nCrewID] = @nCrewID, [dEmbarkedDate] = @dEmbarkedDate, [nContract] = @nContract, [DurationOnboard] = @DurationOnboard, [nCrewIDNext] = @nCrewIDNext, [TGHopDong] = @TGHopDong, [TGDuKienLenTau] = @TGDuKienLenTau, [TGDuKienRoiTau] = @TGDuKienRoiTau, [isDone] = @isDone, [NgayTTXuongTau] = @NgayTTXuongTau, [NgayTTLenTau] = @NgayTTLenTau, [NgayDuKienThayTV] = @NgayDuKienThayTV, [nGhiChu] = @nGhiChu, [NoiLen] = @NoiLen, [NoiXuong] = @NoiXuong, [NgayLenTau] = @NgayLenTau WHERE (([ID] = @Original_ID) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)) AND ((@IsNull_VesselID = 1 AND [VesselID] IS NULL) OR ([VesselID] = @Original_VesselID)) AND ((@IsNull_nCrewID = 1 AND [nCrewID] IS NULL) OR ([nCrewID] = @Original_nCrewID)) AND ((@IsNull_dEmbarkedDate = 1 AND [dEmbarkedDate] IS NULL) OR ([dEmbarkedDate] = @Original_dEmbarkedDate)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_DurationOnboard = 1 AND [DurationOnboard] IS NULL) OR ([DurationOnboard] = @Original_DurationOnboard)) AND ((@IsNull_nCrewIDNext = 1 AND [nCrewIDNext] IS NULL) OR ([nCrewIDNext] = @Original_nCrewIDNext)) AND ((@IsNull_TGHopDong = 1 AND [TGHopDong] IS NULL) OR ([TGHopDong] = @Original_TGHopDong)) AND ((@IsNull_TGDuKienLenTau = 1 AND [TGDuKienLenTau] IS NULL) OR ([TGDuKienLenTau] = @Original_TGDuKienLenTau)) AND ((@IsNull_TGDuKienRoiTau = 1 AND [TGDuKienRoiTau] IS NULL) OR ([TGDuKienRoiTau] = @Original_TGDuKienRoiTau)) AND ((@IsNull_isDone = 1 AND [isDone] IS NULL) OR ([isDone] = @Original_isDone)) AND ((@IsNull_NgayTTXuongTau = 1 AND [NgayTTXuongTau] IS NULL) OR ([NgayTTXuongTau] = @Original_NgayTTXuongTau)) AND ((@IsNull_NgayTTLenTau = 1 AND [NgayTTLenTau] IS NULL) OR ([NgayTTLenTau] = @Original_NgayTTLenTau)) AND ((@IsNull_NgayDuKienThayTV = 1 AND [NgayDuKienThayTV] IS NULL) OR ([NgayDuKienThayTV] = @Original_NgayDuKienThayTV)) AND ((@IsNull_nGhiChu = 1 AND [nGhiChu] IS NULL) OR ([nGhiChu] = @Original_nGhiChu)) AND ((@IsNull_NoiLen = 1 AND [NoiLen] IS NULL) OR ([NoiLen] = @Original_NoiLen)) AND ((@IsNull_NoiXuong = 1 AND [NoiXuong] IS NULL) OR ([NoiXuong] = @Original_NoiXuong)) AND ((@IsNull_NgayLenTau = 1 AND [NgayLenTau] IS NULL) OR ([NgayLenTau] = @Original_NgayLenTau)));
SELECT ID, PlanID, VesselID, nCrewID, dEmbarkedDate, nContract, DurationOnboard, nCrewIDNext, TGHopDong, TGDuKienLenTau, TGDuKienRoiTau, isDone, NgayTTXuongTau, NgayTTLenTau, NgayDuKienThayTV, nGhiChu, NoiLen, NoiXuong, NgayLenTau FROM tblShortPlan WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dEmbarkedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DurationOnboard" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewIDNext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TGHopDong" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@TGDuKienLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@TGDuKienRoiTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayTTXuongTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayTTLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayDuKienThayTV" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoiLen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VesselID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarkedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dEmbarkedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dEmbarkedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DurationOnboard" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DurationOnboard" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurationOnboard" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewIDNext" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewIDNext" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewIDNext" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TGHopDong" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TGHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGDuKienLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_TGDuKienLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TGDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_TGDuKienRoiTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="TGDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTTXuongTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayTTXuongTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTXuongTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTTLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayTTLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayTTLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayDuKienThayTV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayDuKienThayTV" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThayTV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nGhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NoiLen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NoiLen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiLen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NoiXuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoiXuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayLenTau" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="CrewManagment.dbo.tblShortPlan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="VesselID" DataSetColumn="VesselID" />
              <Mapping SourceColumn="nCrewID" DataSetColumn="nCrewID" />
              <Mapping SourceColumn="dEmbarkedDate" DataSetColumn="dEmbarkedDate" />
              <Mapping SourceColumn="DurationOnboard" DataSetColumn="DurationOnboard" />
              <Mapping SourceColumn="nCrewIDNext" DataSetColumn="nCrewIDNext" />
              <Mapping SourceColumn="TGHopDong" DataSetColumn="TGHopDong" />
              <Mapping SourceColumn="TGDuKienLenTau" DataSetColumn="TGDuKienLenTau" />
              <Mapping SourceColumn="TGDuKienRoiTau" DataSetColumn="TGDuKienRoiTau" />
              <Mapping SourceColumn="PlanID" DataSetColumn="PlanID" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="isDone" DataSetColumn="isDone" />
              <Mapping SourceColumn="NgayTTXuongTau" DataSetColumn="NgayTTXuongTau" />
              <Mapping SourceColumn="NgayTTLenTau" DataSetColumn="NgayTTLenTau" />
              <Mapping SourceColumn="NgayDuKienThayTV" DataSetColumn="NgayDuKienThayTV" />
              <Mapping SourceColumn="nGhiChu" DataSetColumn="nGhiChu" />
              <Mapping SourceColumn="NoiLen" DataSetColumn="NoiLen" />
              <Mapping SourceColumn="NoiXuong" DataSetColumn="NoiXuong" />
              <Mapping SourceColumn="NgayLenTau" DataSetColumn="NgayLenTau" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblShortPlan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DurationOnboard, ID, NgayDuKienThayTV, NgayLenTau, NgayTTLenTau, NgayTTXuongTau, NoiLen, NoiXuong, PlanID, TGDuKienLenTau, TGDuKienRoiTau, TGHopDong, VesselID, dEmbarkedDate, isDone, nContract, nCrewID, nCrewIDNext, nGhiChu FROM tblShortPlan WHERE (PlanID = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="PlanID" DataSourceName="CrewManagment.dbo.tblShortPlan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblShortPlan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDSDuKienLen" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillDSDuKienLen" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillDSDuKienLen">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DurationOnboard, ID, NgayDuKienThayTV, NgayLenTau, NgayTTLenTau, NgayTTXuongTau, NoiLen, NoiXuong, PlanID, TGDuKienLenTau, TGDuKienRoiTau, TGHopDong, VesselID, dEmbarkedDate, isDone, nContract, nCrewID, nCrewIDNext, nGhiChu FROM tblShortPlan WHERE (PlanID = @planid) AND (NOT (NgayDuKienThayTV IS NULL)) AND (isDone = 0) AND (NOT (nCrewIDNext IS NULL))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="planid" ColumnName="PlanID" DataSourceName="CrewManagment.dbo.tblShortPlan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@planid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="HuyKeHoach" Modifier="Public" Name="HuyKeHoach" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="HuyKeHoach">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblShortPlan
SET                nCrewIDNext = NULL
WHERE        (ID = @Original_ID);  
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ID" ColumnName="ID" DataSourceName="CrewManagment.dbo.tblShortPlan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblShortPlan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="returnUndonePLan" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="returnUndonePLan" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="returnUndonePLan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DurationOnboard, ID, NgayDuKienThayTV, NgayLenTau, NgayTTLenTau, NgayTTXuongTau, NoiLen, NoiXuong, PlanID, TGDuKienLenTau, TGDuKienRoiTau, TGHopDong, VesselID, dEmbarkedDate, isDone, nContract, nCrewID, nCrewIDNext, nGhiChu FROM tblShortPlan WHERE (isDone = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblKeHoachTableAdapter" GeneratorDataComponentClassName="tblKeHoachTableAdapter" Name="tblKeHoach" UserDataComponentName="tblKeHoachTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblKeHoach" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblKeHoach] WHERE (([Planid] = @Original_Planid) AND ((@IsNull_Tên_kế_hoạch = 1 AND [Tên kế hoạch] IS NULL) OR ([Tên kế hoạch] = @Original_Tên_kế_hoạch)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Ngày_lập_kế_hoạch = 1 AND [Ngày lập kế hoạch] IS NULL) OR ([Ngày lập kế hoạch] = @Original_Ngày_lập_kế_hoạch)) AND ((@IsNull_Ngày_chỉnh_sửa = 1 AND [Ngày chỉnh sửa] IS NULL) OR ([Ngày chỉnh sửa] = @Original_Ngày_chỉnh_sửa)) AND ((@IsNull_isLongPlan = 1 AND [isLongPlan] IS NULL) OR ([isLongPlan] = @Original_isLongPlan)) AND ((@IsNull_Từ = 1 AND [Từ] IS NULL) OR ([Từ] = @Original_Từ)) AND ((@IsNull_Đến = 1 AND [Đến] IS NULL) OR ([Đến] = @Original_Đến)) AND ((@IsNull_Đã_duyệt = 1 AND [Đã duyệt] IS NULL) OR ([Đã duyệt] = @Original_Đã_duyệt)) AND ((@IsNull_IsDone = 1 AND [IsDone] IS NULL) OR ([IsDone] = @Original_IsDone)) AND ((@IsNull_NguoiChinhSua = 1 AND [NguoiChinhSua] IS NULL) OR ([NguoiChinhSua] = @Original_NguoiChinhSua)) AND ((@IsNull_NgayDuKienThucHien = 1 AND [NgayDuKienThucHien] IS NULL) OR ([NgayDuKienThucHien] = @Original_NgayDuKienThucHien)) AND ((@IsNull_CangDuKien = 1 AND [CangDuKien] IS NULL) OR ([CangDuKien] = @Original_CangDuKien)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Planid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tên_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_chỉnh_sửa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isLongPlan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Từ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đến" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_duyệt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguoiChinhSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayDuKienThucHien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayDuKienThucHien" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CangDuKien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CangDuKien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblKeHoach] ([Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], [isLongPlan], [Mô tả], [Từ], [Đến], [Đã duyệt], [IsDone], [NguoiChinhSua], [NgayDuKienThucHien], [CangDuKien]) VALUES (@Tên_kế_hoạch, @Người_lập_kế_hoạch, @Ngày_lập_kế_hoạch, @Ngày_chỉnh_sửa, @isLongPlan, @Mô_tả, @Từ, @Đến, @Đã_duyệt, @IsDone, @NguoiChinhSua, @NgayDuKienThucHien, @CangDuKien);
SELECT Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], IsDone, NguoiChinhSua, NgayDuKienThucHien, CangDuKien FROM tblKeHoach WHERE (Planid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mô_tả" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mô tả" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayDuKienThucHien" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CangDuKien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], IsDone, NguoiChinhSua, NgayDuKienThucHien, 
                         CangDuKien
FROM            tblKeHoach</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblKeHoach] SET [Tên kế hoạch] = @Tên_kế_hoạch, [Người lập kế hoạch] = @Người_lập_kế_hoạch, [Ngày lập kế hoạch] = @Ngày_lập_kế_hoạch, [Ngày chỉnh sửa] = @Ngày_chỉnh_sửa, [isLongPlan] = @isLongPlan, [Mô tả] = @Mô_tả, [Từ] = @Từ, [Đến] = @Đến, [Đã duyệt] = @Đã_duyệt, [IsDone] = @IsDone, [NguoiChinhSua] = @NguoiChinhSua, [NgayDuKienThucHien] = @NgayDuKienThucHien, [CangDuKien] = @CangDuKien WHERE (([Planid] = @Original_Planid) AND ((@IsNull_Tên_kế_hoạch = 1 AND [Tên kế hoạch] IS NULL) OR ([Tên kế hoạch] = @Original_Tên_kế_hoạch)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Ngày_lập_kế_hoạch = 1 AND [Ngày lập kế hoạch] IS NULL) OR ([Ngày lập kế hoạch] = @Original_Ngày_lập_kế_hoạch)) AND ((@IsNull_Ngày_chỉnh_sửa = 1 AND [Ngày chỉnh sửa] IS NULL) OR ([Ngày chỉnh sửa] = @Original_Ngày_chỉnh_sửa)) AND ((@IsNull_isLongPlan = 1 AND [isLongPlan] IS NULL) OR ([isLongPlan] = @Original_isLongPlan)) AND ((@IsNull_Từ = 1 AND [Từ] IS NULL) OR ([Từ] = @Original_Từ)) AND ((@IsNull_Đến = 1 AND [Đến] IS NULL) OR ([Đến] = @Original_Đến)) AND ((@IsNull_Đã_duyệt = 1 AND [Đã duyệt] IS NULL) OR ([Đã duyệt] = @Original_Đã_duyệt)) AND ((@IsNull_IsDone = 1 AND [IsDone] IS NULL) OR ([IsDone] = @Original_IsDone)) AND ((@IsNull_NguoiChinhSua = 1 AND [NguoiChinhSua] IS NULL) OR ([NguoiChinhSua] = @Original_NguoiChinhSua)) AND ((@IsNull_NgayDuKienThucHien = 1 AND [NgayDuKienThucHien] IS NULL) OR ([NgayDuKienThucHien] = @Original_NgayDuKienThucHien)) AND ((@IsNull_CangDuKien = 1 AND [CangDuKien] IS NULL) OR ([CangDuKien] = @Original_CangDuKien)));
SELECT Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], IsDone, NguoiChinhSua, NgayDuKienThucHien, CangDuKien FROM tblKeHoach WHERE (Planid = @Planid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mô_tả" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mô tả" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayDuKienThucHien" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CangDuKien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Planid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tên_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_chỉnh_sửa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isLongPlan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Từ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đến" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_duyệt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguoiChinhSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayDuKienThucHien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayDuKienThucHien" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayDuKienThucHien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CangDuKien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CangDuKien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CangDuKien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Planid" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Planid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Planid" DataSetColumn="Planid" />
              <Mapping SourceColumn="Tên kế hoạch" DataSetColumn="Tên kế hoạch" />
              <Mapping SourceColumn="Người lập kế hoạch" DataSetColumn="Người lập kế hoạch" />
              <Mapping SourceColumn="Ngày lập kế hoạch" DataSetColumn="Ngày lập kế hoạch" />
              <Mapping SourceColumn="Ngày chỉnh sửa" DataSetColumn="Ngày chỉnh sửa" />
              <Mapping SourceColumn="isLongPlan" DataSetColumn="isLongPlan" />
              <Mapping SourceColumn="Mô tả" DataSetColumn="Mô tả" />
              <Mapping SourceColumn="Từ" DataSetColumn="Từ" />
              <Mapping SourceColumn="Đến" DataSetColumn="Đến" />
              <Mapping SourceColumn="Đã duyệt" DataSetColumn="Đã duyệt" />
              <Mapping SourceColumn="NguoiChinhSua" DataSetColumn="NguoiChinhSua" />
              <Mapping SourceColumn="NgayDuKienThucHien" DataSetColumn="NgayDuKienThucHien" />
              <Mapping SourceColumn="IsDone" DataSetColumn="IsDone" />
              <Mapping SourceColumn="CangDuKien" DataSetColumn="CangDuKien" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteKeHoach" Modifier="Public" Name="DeleteKeHoach" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteKeHoach">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM tblKeHoach
WHERE        (Planid = @Planid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Planid" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Planid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Done" Modifier="Public" Name="Done" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="Done">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblKeHoach
SET                isDone = @isDone
WHERE        (Planid = @id); 
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="isDone" ColumnName="isDone" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isDone" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblKeHoach" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CangDuKien, IsDone, [Mô tả], NgayDuKienThucHien, NguoiChinhSua, [Ngày chỉnh sửa], [Ngày lập kế hoạch], [Người lập kế hoạch], Planid, [Tên kế hoạch], Từ, isLongPlan, [Đã duyệt], Đến FROM tblKeHoach WHERE (Planid = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tadCurrentOnboard" GeneratorDataComponentClassName="tadCurrentOnboard" Name="tblCurrentOnboard" UserDataComponentName="tadCurrentOnboard">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblAssignment.dEmbarked, MONTH(tblAssignment.dEmbarked) AS Thang, YEAR(tblAssignment.dEmbarked) AS nam, tblAssignment.nCrewid, 
                         tblAssignment.nVesselId, tblCrew.nRankID, tblCrewType.cTypeName, tblRank.iRankType, tblAssignment.dDuKienRoiTau, tblAssignment.nContract, 
                         tblRank.nRankLevel
FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId LEFT OUTER JOIN
                         tblCrewType ON tblRank.iRankType = tblCrewType.id
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board')
ORDER BY tblAssignment.nVesselId, tblRank.nRankLevel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="Thang" DataSetColumn="Thang" />
              <Mapping SourceColumn="nam" DataSetColumn="nam" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cTypeName" DataSetColumn="cTypeName" />
              <Mapping SourceColumn="iRankType" DataSetColumn="iRankType" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="nRankLevel" DataSetColumn="nRankLevel" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByVessel" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByVessel" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByVessel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblAssignment.dEmbarked, MONTH(tblAssignment.dEmbarked) AS Thang, YEAR(tblAssignment.dEmbarked) AS nam, tblAssignment.nCrewid, 
                         tblAssignment.nVesselId, tblCrew.nRankID, tblCrewType.cTypeName, tblRank.iRankType, tblAssignment.dDuKienRoiTau, tblAssignment.nContract, 
                         tblRank.nRankLevel
FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId LEFT OUTER JOIN
                         tblCrewType ON tblRank.iRankType = tblCrewType.id
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board') AND (tblAssignment.nVesselId = @id)
ORDER BY tblAssignment.nVesselId, tblRank.nRankLevel</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="nVesselId" DataSourceName="CrewManagment.dbo.tblAssignment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tadCrew" GeneratorDataComponentClassName="tadCrew" Name="tblCrew" UserDataComponentName="tadCrew">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblRank.cRankName, tblCrew.nCrewId, tblCrew.nRankID, tblCrew.cCMT, tblCrew.dDateOfBirth, 
                         tblCrew.cAddress, tblCrew.cPlaceOfBirth, tblPhuongXa.TenPhuongXa, tblQuanHuyen.TenQuanHuyen, tblTinhThanh.TenTinhThanh, tblCrew.cHandNo, 
                         tblCrew.cHomeNo
FROM            tblQuanHuyen INNER JOIN
                         tblPhuongXa ON tblQuanHuyen.QuanHuyenID = tblPhuongXa.QuanHuyenID INNER JOIN
                         tblTinhThanh ON tblQuanHuyen.TinhThanhID = tblTinhThanh.TinhThanhID RIGHT OUTER JOIN
                         tblCrew INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId ON tblPhuongXa.PhuongXaID = tblCrew.PhuongXaID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cCMT" DataSetColumn="cCMT" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cPlaceOfBirth" DataSetColumn="cPlaceOfBirth" />
              <Mapping SourceColumn="TenPhuongXa" DataSetColumn="TenPhuongXa" />
              <Mapping SourceColumn="TenQuanHuyen" DataSetColumn="TenQuanHuyen" />
              <Mapping SourceColumn="TenTinhThanh" DataSetColumn="TenTinhThanh" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblRank.cRankName, tblCrew.nCrewId, tblCrew.nRankID, tblCrew.cCMT, tblCrew.dDateOfBirth, 
                         tblCrew.cAddress, tblCrew.cPlaceOfBirth, tblPhuongXa.TenPhuongXa, tblQuanHuyen.TenQuanHuyen, tblTinhThanh.TenTinhThanh, tblCrew.cHandNo, 
                         tblCrew.cHomeNo
FROM            tblCrew INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId INNER JOIN
                         tblPhuongXa ON tblCrew.PhuongXaID = tblPhuongXa.PhuongXaID INNER JOIN
                         tblQuanHuyen ON tblPhuongXa.QuanHuyenID = tblQuanHuyen.QuanHuyenID INNER JOIN
                         tblTinhThanh ON tblQuanHuyen.TinhThanhID = tblTinhThanh.TinhThanhID
where tblCrew.nCrewId =@id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblRankTableAdapter" GeneratorDataComponentClassName="tblRankTableAdapter" Name="tblRank" UserDataComponentName="tblRankTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblRank] WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)) AND ((@IsNull_Monthly_leave_pay = 1 AND [Monthly leave pay] IS NULL) OR ([Monthly leave pay] = @Original_Monthly_leave_pay)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monthly_leave_pay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblRank] ([cRankName], [nRankLevel], [cRankDescription], [iRankType], [BasicMonthlyWages], [Overtime A], [Overtime B], [SubsisAllowence], [Monthly leave pay]) VALUES (@cRankName, @nRankLevel, @cRankDescription, @iRankType, @BasicMonthlyWages, @Overtime_A, @Overtime_B, @SubsisAllowence, @Monthly_leave_pay);
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime A], [Overtime B], SubsisAllowence, [Monthly leave pay] FROM tblRank WHERE (nRankId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblRank.*
FROM            tblRank</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblRank] SET [cRankName] = @cRankName, [nRankLevel] = @nRankLevel, [cRankDescription] = @cRankDescription, [iRankType] = @iRankType, [BasicMonthlyWages] = @BasicMonthlyWages, [Overtime A] = @Overtime_A, [Overtime B] = @Overtime_B, [SubsisAllowence] = @SubsisAllowence, [Monthly leave pay] = @Monthly_leave_pay WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)) AND ((@IsNull_Monthly_leave_pay = 1 AND [Monthly leave pay] IS NULL) OR ([Monthly leave pay] = @Original_Monthly_leave_pay)));
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime A], [Overtime B], SubsisAllowence, [Monthly leave pay] FROM tblRank WHERE (nRankId = @nRankId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monthly_leave_pay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nRankId" ColumnName="nRankId" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="nRankLevel" DataSetColumn="nRankLevel" />
              <Mapping SourceColumn="cRankDescription" DataSetColumn="cRankDescription" />
              <Mapping SourceColumn="iRankType" DataSetColumn="iRankType" />
              <Mapping SourceColumn="BasicMonthlyWages" DataSetColumn="BasicMonthlyWages" />
              <Mapping SourceColumn="Overtime A" DataSetColumn="Overtime A" />
              <Mapping SourceColumn="Overtime B" DataSetColumn="Overtime B" />
              <Mapping SourceColumn="SubsisAllowence" DataSetColumn="SubsisAllowence" />
              <Mapping SourceColumn="Monthly leave pay" DataSetColumn="Monthly leave pay" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="returnLowerRank" Modifier="Public" Name="returnLowerRank" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="returnLowerRank">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nRankId
FROM            tblRank
WHERE        (iRankType = @type) AND (nRankLevel = @level)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="type" ColumnName="iRankType" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="level" ColumnName="nRankLevel" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="returnMaxLevel" Modifier="Public" Name="returnMaxLevel" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="returnMaxLevel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(nRankLevel) AS Expr1
FROM            tblRank
WHERE        (iRankType = @type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="type" ColumnName="iRankType" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="returnRankTypeID_RankLevel" GeneratorSourceName="returnRankTypeID" GetMethodModifier="Public" GetMethodName="returnRankTypeID_RankLevel" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="returnRankTypeID_RankLevel" UserSourceName="returnRankTypeID_RankLevel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        iRankType, nRankLevel
FROM            tblRank
WHERE        (cRankName = @rankName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="rankName" ColumnName="cRankName" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="nvarchar(200)" DbType="String" Direction="Input" ParameterName="@rankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tadSuggestCrewList" GeneratorDataComponentClassName="tadSuggestCrewList" Name="tblSuggestCrewList" UserDataComponentName="tadSuggestCrewList">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nRankID, tblCrew.nCrewId, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblAssignment.cStatus, tblAssignment.nVesselId, 
                         tblAssignment.isActive, tblRank.cRankName, tblAssignment.dDuKienRoiTau, tblAssignment.cGhiChu, tblAssignment.dLeave, tblAssignment.nRequest, 
                         tblCrew.cHandNo, tblCrew.cHomeNo, tblRank.nRankLevel, tblCrew.bImage, tblAssignment.dEmbarked
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew') AND (tblRank.cRankName = @rankName) OR
                         (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew') AND (tblCrew.nRankID = @rankLower) OR
                         (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board') AND (tblCrew.nRankID = @rankLower) AND (tblAssignment.nVesselId = @vesselID) OR
                         (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew') AND (tblCrew.nRankID = @rankLower2) OR
                         (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board') AND (tblCrew.nRankID = @rankLower2) AND (tblAssignment.nVesselId = @vesselID)
ORDER BY tblRank.nRankLevel</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="rankName" ColumnName="cRankName" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="nvarchar(200)" DbType="String" Direction="Input" ParameterName="@rankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rankLower" ColumnName="nRankID" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rankLower" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="vesselID" ColumnName="nVesselId" DataSourceName="CrewManagment.dbo.tblAssignment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@vesselID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rankLower2" ColumnName="nRankID" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rankLower2" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="cGhiChu" DataSetColumn="cGhiChu" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="nRankLevel" DataSetColumn="nRankLevel" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillAll" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillAll">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nRankID, tblCrew.nCrewId, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblAssignment.cStatus, tblAssignment.nVesselId, 
                         tblAssignment.isActive, tblRank.cRankName, tblAssignment.dDuKienRoiTau, tblAssignment.cGhiChu, tblAssignment.dLeave, tblAssignment.nRequest, 
                         tblCrew.cHandNo, tblCrew.cHomeNo, tblRank.nRankLevel, tblCrew.bImage, tblAssignment.dEmbarked
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew')
ORDER BY tblRank.nRankLevel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByType" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nRankID, tblCrew.nCrewId, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblAssignment.cStatus, tblAssignment.nVesselId, 
                         tblAssignment.isActive, tblRank.cRankName, tblAssignment.dDuKienRoiTau, tblAssignment.cGhiChu, tblAssignment.dLeave, tblAssignment.nRequest, 
                         tblCrew.cHandNo, tblCrew.cHomeNo, tblRank.nRankLevel, tblCrew.bImage, tblAssignment.dEmbarked
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Vacation' OR
                         tblAssignment.cStatus = N'New Crew') OR
                         (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = N'On Board') AND (tblAssignment.nVesselId = @vesselID)
ORDER BY tblRank.nRankLevel</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="vesselID" ColumnName="nVesselId" DataSourceName="CrewManagment.dbo.tblAssignment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@vesselID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentTableAdapter" GeneratorDataComponentClassName="tblAssignmentTableAdapter" Name="tblAssignment" UserDataComponentName="tblAssignmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblAssignment] WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)) AND ((@IsNull_cNoiXuong = 1 AND [cNoiXuong] IS NULL) OR ([cNoiXuong] = @Original_cNoiXuong)) AND ((@IsNull_cNoiDi = 1 AND [cNoiDi] IS NULL) OR ([cNoiDi] = @Original_cNoiDi)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNoiXuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNoiDi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNoiDi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblAssignment] ([nCrewid], [nVesselId], [cStatus], [cDescription], [dEmbarked], [nContract], [dLeave], [nRequest], [dDuKienRoiTau], [dSanSangLenTau], [dCatHopDong], [dNghiHuu], [dKyHopDong], [dModified], [isActive], [cNoiXuong], [cNoiDi], [cGhiChu]) VALUES (@nCrewid, @nVesselId, @cStatus, @cDescription, @dEmbarked, @nContract, @dLeave, @nRequest, @dDuKienRoiTau, @dSanSangLenTau, @dCatHopDong, @dNghiHuu, @dKyHopDong, @dModified, @isActive, @cNoiXuong, @cNoiDi, @cGhiChu);
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cNoiXuong, cNoiDi, cGhiChu FROM tblAssignment WHERE (nAssignmentId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNoiDi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cNoiXuong, cNoiDi, cGhiChu FROM dbo.tblAssignment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblAssignment] SET [nCrewid] = @nCrewid, [nVesselId] = @nVesselId, [cStatus] = @cStatus, [cDescription] = @cDescription, [dEmbarked] = @dEmbarked, [nContract] = @nContract, [dLeave] = @dLeave, [nRequest] = @nRequest, [dDuKienRoiTau] = @dDuKienRoiTau, [dSanSangLenTau] = @dSanSangLenTau, [dCatHopDong] = @dCatHopDong, [dNghiHuu] = @dNghiHuu, [dKyHopDong] = @dKyHopDong, [dModified] = @dModified, [isActive] = @isActive, [cNoiXuong] = @cNoiXuong, [cNoiDi] = @cNoiDi, [cGhiChu] = @cGhiChu WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)) AND ((@IsNull_cNoiXuong = 1 AND [cNoiXuong] IS NULL) OR ([cNoiXuong] = @Original_cNoiXuong)) AND ((@IsNull_cNoiDi = 1 AND [cNoiDi] IS NULL) OR ([cNoiDi] = @Original_cNoiDi)));
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cNoiXuong, cNoiDi, cGhiChu FROM tblAssignment WHERE (nAssignmentId = @nAssignmentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNoiDi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNoiXuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNoiXuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiXuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNoiDi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNoiDi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNoiDi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nAssignmentId" ColumnName="nAssignmentId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nAssignmentId" DataSetColumn="nAssignmentId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="dSanSangLenTau" DataSetColumn="dSanSangLenTau" />
              <Mapping SourceColumn="dCatHopDong" DataSetColumn="dCatHopDong" />
              <Mapping SourceColumn="dNghiHuu" DataSetColumn="dNghiHuu" />
              <Mapping SourceColumn="dKyHopDong" DataSetColumn="dKyHopDong" />
              <Mapping SourceColumn="dModified" DataSetColumn="dModified" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="cNoiXuong" DataSetColumn="cNoiXuong" />
              <Mapping SourceColumn="cNoiDi" DataSetColumn="cNoiDi" />
              <Mapping SourceColumn="cGhiChu" DataSetColumn="cGhiChu" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateRank" MethodsParameterType="CLR" Modifier="Public" Name="UpdateRank" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateRank">
            <UpdateCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>UPDATE       tblCrew
SET                nRankID = @RANKID
WHERE        (nCrewId = @id)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="RANKID" ColumnName="nRankID" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RANKID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                </Parameters>
              </DbCommand>
            </UpdateCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsShortPlan" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsShortPlan" msprop:Generator_UserDSName="dsShortPlan">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblVessel" msprop:Generator_TableClassName="tblVesselDataTable" msprop:Generator_TableVarName="tabletblVessel" msprop:Generator_TablePropName="tblVessel" msprop:Generator_RowDeletingName="tblVesselRowDeleting" msprop:Generator_UserTableName="tblVessel" msprop:Generator_RowChangingName="tblVesselRowChanging" msprop:Generator_RowEvHandlerName="tblVesselRowChangeEventHandler" msprop:Generator_RowDeletedName="tblVesselRowDeleted" msprop:Generator_RowEvArgName="tblVesselRowChangeEvent" msprop:Generator_RowChangedName="tblVesselRowChanged" msprop:Generator_RowClassName="tblVesselRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nVesselId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cShortName" msprop:Generator_ColumnVarNameInTable="columncShortName" msprop:Generator_ColumnPropNameInRow="cShortName" msprop:Generator_ColumnPropNameInTable="cShortNameColumn" msprop:Generator_UserColumnName="cShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nGroupId" msprop:Generator_ColumnVarNameInTable="columnnGroupId" msprop:Generator_ColumnPropNameInRow="nGroupId" msprop:Generator_ColumnPropNameInTable="nGroupIdColumn" msprop:Generator_UserColumnName="nGroupId" type="xs:int" minOccurs="0" />
              <xs:element name="nFlagId" msprop:Generator_ColumnVarNameInTable="columnnFlagId" msprop:Generator_ColumnPropNameInRow="nFlagId" msprop:Generator_ColumnPropNameInTable="nFlagIdColumn" msprop:Generator_UserColumnName="nFlagId" type="xs:int" minOccurs="0" />
              <xs:element name="nVesselTypeId" msprop:Generator_ColumnVarNameInTable="columnnVesselTypeId" msprop:Generator_ColumnPropNameInRow="nVesselTypeId" msprop:Generator_ColumnPropNameInTable="nVesselTypeIdColumn" msprop:Generator_UserColumnName="nVesselTypeId" type="xs:int" minOccurs="0" />
              <xs:element name="fGRT" msprop:Generator_ColumnVarNameInTable="columnfGRT" msprop:Generator_ColumnPropNameInRow="fGRT" msprop:Generator_ColumnPropNameInTable="fGRTColumn" msprop:Generator_UserColumnName="fGRT" type="xs:double" minOccurs="0" />
              <xs:element name="cTradeArea" msprop:Generator_ColumnVarNameInTable="columncTradeArea" msprop:Generator_ColumnPropNameInRow="cTradeArea" msprop:Generator_ColumnPropNameInTable="cTradeAreaColumn" msprop:Generator_UserColumnName="cTradeArea" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cImoNumber" msprop:Generator_ColumnVarNameInTable="columncImoNumber" msprop:Generator_ColumnPropNameInRow="cImoNumber" msprop:Generator_ColumnPropNameInTable="cImoNumberColumn" msprop:Generator_UserColumnName="cImoNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPortOfRegistry" msprop:Generator_ColumnVarNameInTable="columncPortOfRegistry" msprop:Generator_ColumnPropNameInRow="cPortOfRegistry" msprop:Generator_ColumnPropNameInTable="cPortOfRegistryColumn" msprop:Generator_UserColumnName="cPortOfRegistry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dYearBuilt" msprop:Generator_ColumnVarNameInTable="columndYearBuilt" msprop:Generator_ColumnPropNameInRow="dYearBuilt" msprop:Generator_ColumnPropNameInTable="dYearBuiltColumn" msprop:Generator_UserColumnName="dYearBuilt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nEngineType" msprop:Generator_ColumnVarNameInTable="columnnEngineType" msprop:Generator_ColumnPropNameInRow="nEngineType" msprop:Generator_ColumnPropNameInTable="nEngineTypeColumn" msprop:Generator_UserColumnName="nEngineType" type="xs:int" minOccurs="0" />
              <xs:element name="nEngineMaker" msprop:Generator_ColumnVarNameInTable="columnnEngineMaker" msprop:Generator_ColumnPropNameInRow="nEngineMaker" msprop:Generator_ColumnPropNameInTable="nEngineMakerColumn" msprop:Generator_UserColumnName="nEngineMaker" type="xs:int" minOccurs="0" />
              <xs:element name="fHorsePower" msprop:Generator_ColumnVarNameInTable="columnfHorsePower" msprop:Generator_ColumnPropNameInRow="fHorsePower" msprop:Generator_ColumnPropNameInTable="fHorsePowerColumn" msprop:Generator_UserColumnName="fHorsePower" type="xs:double" minOccurs="0" />
              <xs:element name="cVesselManaged" msprop:Generator_ColumnVarNameInTable="columncVesselManaged" msprop:Generator_ColumnPropNameInRow="cVesselManaged" msprop:Generator_ColumnPropNameInTable="cVesselManagedColumn" msprop:Generator_UserColumnName="cVesselManaged" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblVesselGroup" msprop:Generator_TableClassName="tblVesselGroupDataTable" msprop:Generator_TableVarName="tabletblVesselGroup" msprop:Generator_TablePropName="tblVesselGroup" msprop:Generator_RowDeletingName="tblVesselGroupRowDeleting" msprop:Generator_UserTableName="tblVesselGroup" msprop:Generator_RowChangingName="tblVesselGroupRowChanging" msprop:Generator_RowEvHandlerName="tblVesselGroupRowChangeEventHandler" msprop:Generator_RowDeletedName="tblVesselGroupRowDeleted" msprop:Generator_RowEvArgName="tblVesselGroupRowChangeEvent" msprop:Generator_RowChangedName="tblVesselGroupRowChanged" msprop:Generator_RowClassName="tblVesselGroupRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nGroupId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnGroupId" msprop:Generator_ColumnPropNameInRow="nGroupId" msprop:Generator_ColumnPropNameInTable="nGroupIdColumn" msprop:Generator_UserColumnName="nGroupId" type="xs:int" />
              <xs:element name="cGroupName" msprop:Generator_ColumnVarNameInTable="columncGroupName" msprop:Generator_ColumnPropNameInRow="cGroupName" msprop:Generator_ColumnPropNameInTable="cGroupNameColumn" msprop:Generator_UserColumnName="cGroupName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblShortPlan" msprop:Generator_TableClassName="tblShortPlanDataTable" msprop:Generator_TableVarName="tabletblShortPlan" msprop:Generator_TablePropName="tblShortPlan" msprop:Generator_RowDeletingName="tblShortPlanRowDeleting" msprop:Generator_UserTableName="tblShortPlan" msprop:Generator_RowChangingName="tblShortPlanRowChanging" msprop:Generator_RowEvHandlerName="tblShortPlanRowChangeEventHandler" msprop:Generator_RowDeletedName="tblShortPlanRowDeleted" msprop:Generator_RowEvArgName="tblShortPlanRowChangeEvent" msprop:Generator_RowChangedName="tblShortPlanRowChanged" msprop:Generator_RowClassName="tblShortPlanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="VesselID" msprop:Generator_ColumnVarNameInTable="columnVesselID" msprop:Generator_ColumnPropNameInRow="VesselID" msprop:Generator_ColumnPropNameInTable="VesselIDColumn" msprop:Generator_UserColumnName="VesselID" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewID" msprop:Generator_ColumnVarNameInTable="columnnCrewID" msprop:Generator_ColumnPropNameInRow="nCrewID" msprop:Generator_ColumnPropNameInTable="nCrewIDColumn" msprop:Generator_UserColumnName="nCrewID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarkedDate" msprop:Generator_ColumnVarNameInTable="columndEmbarkedDate" msprop:Generator_ColumnPropNameInRow="dEmbarkedDate" msprop:Generator_ColumnPropNameInTable="dEmbarkedDateColumn" msprop:Generator_UserColumnName="dEmbarkedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DurationOnboard" msprop:Generator_ColumnVarNameInTable="columnDurationOnboard" msprop:Generator_ColumnPropNameInRow="DurationOnboard" msprop:Generator_ColumnPropNameInTable="DurationOnboardColumn" msprop:Generator_UserColumnName="DurationOnboard" type="xs:double" minOccurs="0" />
              <xs:element name="nCrewIDNext" msprop:Generator_ColumnVarNameInTable="columnnCrewIDNext" msprop:Generator_ColumnPropNameInRow="nCrewIDNext" msprop:Generator_ColumnPropNameInTable="nCrewIDNextColumn" msprop:Generator_UserColumnName="nCrewIDNext" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TGHopDong" msprop:Generator_ColumnVarNameInTable="columnTGHopDong" msprop:Generator_ColumnPropNameInRow="TGHopDong" msprop:Generator_ColumnPropNameInTable="TGHopDongColumn" msprop:Generator_UserColumnName="TGHopDong" type="xs:short" minOccurs="0" />
              <xs:element name="TGDuKienLenTau" msprop:Generator_ColumnVarNameInTable="columnTGDuKienLenTau" msprop:Generator_ColumnPropNameInRow="TGDuKienLenTau" msprop:Generator_ColumnPropNameInTable="TGDuKienLenTauColumn" msprop:Generator_UserColumnName="TGDuKienLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TGDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columnTGDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="TGDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="TGDuKienRoiTauColumn" msprop:Generator_UserColumnName="TGDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PlanID" msprop:Generator_ColumnVarNameInTable="columnPlanID" msprop:Generator_ColumnPropNameInRow="PlanID" msprop:Generator_ColumnPropNameInTable="PlanIDColumn" msprop:Generator_UserColumnName="PlanID" type="xs:int" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:short" minOccurs="0" />
              <xs:element name="isDone" msprop:Generator_ColumnVarNameInTable="columnisDone" msprop:Generator_ColumnPropNameInRow="isDone" msprop:Generator_ColumnPropNameInTable="isDoneColumn" msprop:Generator_UserColumnName="isDone" type="xs:boolean" minOccurs="0" />
              <xs:element name="NgayTTXuongTau" msprop:Generator_ColumnVarNameInTable="columnNgayTTXuongTau" msprop:Generator_ColumnPropNameInRow="NgayTTXuongTau" msprop:Generator_ColumnPropNameInTable="NgayTTXuongTauColumn" msprop:Generator_UserColumnName="NgayTTXuongTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NgayTTLenTau" msprop:Generator_ColumnVarNameInTable="columnNgayTTLenTau" msprop:Generator_ColumnPropNameInRow="NgayTTLenTau" msprop:Generator_ColumnPropNameInTable="NgayTTLenTauColumn" msprop:Generator_UserColumnName="NgayTTLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NgayDuKienThayTV" msprop:Generator_ColumnVarNameInTable="columnNgayDuKienThayTV" msprop:Generator_ColumnPropNameInRow="NgayDuKienThayTV" msprop:Generator_ColumnPropNameInTable="NgayDuKienThayTVColumn" msprop:Generator_UserColumnName="NgayDuKienThayTV" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nGhiChu" msprop:Generator_ColumnVarNameInTable="columnnGhiChu" msprop:Generator_ColumnPropNameInRow="nGhiChu" msprop:Generator_ColumnPropNameInTable="nGhiChuColumn" msprop:Generator_UserColumnName="nGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoiLen" msprop:Generator_ColumnVarNameInTable="columnNoiLen" msprop:Generator_ColumnPropNameInRow="NoiLen" msprop:Generator_ColumnPropNameInTable="NoiLenColumn" msprop:Generator_UserColumnName="NoiLen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoiXuong" msprop:Generator_ColumnVarNameInTable="columnNoiXuong" msprop:Generator_ColumnPropNameInRow="NoiXuong" msprop:Generator_ColumnPropNameInTable="NoiXuongColumn" msprop:Generator_UserColumnName="NoiXuong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayLenTau" msprop:Generator_ColumnVarNameInTable="columnNgayLenTau" msprop:Generator_ColumnPropNameInRow="NgayLenTau" msprop:Generator_ColumnPropNameInTable="NgayLenTauColumn" msprop:Generator_UserColumnName="NgayLenTau" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblKeHoach" msprop:Generator_TableClassName="tblKeHoachDataTable" msprop:Generator_TableVarName="tabletblKeHoach" msprop:Generator_TablePropName="tblKeHoach" msprop:Generator_RowDeletingName="tblKeHoachRowDeleting" msprop:Generator_UserTableName="tblKeHoach" msprop:Generator_RowChangingName="tblKeHoachRowChanging" msprop:Generator_RowEvHandlerName="tblKeHoachRowChangeEventHandler" msprop:Generator_RowDeletedName="tblKeHoachRowDeleted" msprop:Generator_RowEvArgName="tblKeHoachRowChangeEvent" msprop:Generator_RowChangedName="tblKeHoachRowChanged" msprop:Generator_RowClassName="tblKeHoachRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Planid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPlanid" msprop:Generator_ColumnPropNameInRow="Planid" msprop:Generator_ColumnPropNameInTable="PlanidColumn" msprop:Generator_UserColumnName="Planid" type="xs:int" />
              <xs:element name="Tên_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnTên_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Tên_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Tên_kế_hoạchColumn" msprop:Generator_UserColumnName="Tên kế hoạch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Người_x0020_lập_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnNgười_lập_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Người_lập_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Người_lập_kế_hoạchColumn" msprop:Generator_UserColumnName="Người lập kế hoạch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ngày_x0020_lập_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnNgày_lập_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Ngày_lập_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Ngày_lập_kế_hoạchColumn" msprop:Generator_UserColumnName="Ngày lập kế hoạch" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Ngày_x0020_chỉnh_x0020_sửa" msprop:Generator_ColumnVarNameInTable="columnNgày_chỉnh_sửa" msprop:Generator_ColumnPropNameInRow="Ngày_chỉnh_sửa" msprop:Generator_ColumnPropNameInTable="Ngày_chỉnh_sửaColumn" msprop:Generator_UserColumnName="Ngày chỉnh sửa" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isLongPlan" msprop:Generator_ColumnVarNameInTable="columnisLongPlan" msprop:Generator_ColumnPropNameInRow="isLongPlan" msprop:Generator_ColumnPropNameInTable="isLongPlanColumn" msprop:Generator_UserColumnName="isLongPlan" type="xs:boolean" minOccurs="0" />
              <xs:element name="Mô_x0020_tả" msprop:Generator_ColumnVarNameInTable="columnMô_tả" msprop:Generator_ColumnPropNameInRow="Mô_tả" msprop:Generator_ColumnPropNameInTable="Mô_tảColumn" msprop:Generator_UserColumnName="Mô tả" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Từ" msprop:Generator_ColumnVarNameInTable="columnTừ" msprop:Generator_ColumnPropNameInRow="Từ" msprop:Generator_ColumnPropNameInTable="TừColumn" msprop:Generator_UserColumnName="Từ" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Đến" msprop:Generator_ColumnVarNameInTable="columnĐến" msprop:Generator_ColumnPropNameInRow="Đến" msprop:Generator_ColumnPropNameInTable="ĐếnColumn" msprop:Generator_UserColumnName="Đến" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Đã_x0020_duyệt" msprop:Generator_ColumnVarNameInTable="columnĐã_duyệt" msprop:Generator_ColumnPropNameInRow="Đã_duyệt" msprop:Generator_ColumnPropNameInTable="Đã_duyệtColumn" msprop:Generator_UserColumnName="Đã duyệt" type="xs:boolean" minOccurs="0" />
              <xs:element name="NguoiChinhSua" msprop:Generator_ColumnVarNameInTable="columnNguoiChinhSua" msprop:Generator_ColumnPropNameInRow="NguoiChinhSua" msprop:Generator_ColumnPropNameInTable="NguoiChinhSuaColumn" msprop:Generator_UserColumnName="NguoiChinhSua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayDuKienThucHien" msprop:Generator_ColumnVarNameInTable="columnNgayDuKienThucHien" msprop:Generator_ColumnPropNameInRow="NgayDuKienThucHien" msprop:Generator_ColumnPropNameInTable="NgayDuKienThucHienColumn" msprop:Generator_UserColumnName="NgayDuKienThucHien" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IsDone" msprop:Generator_ColumnVarNameInTable="columnIsDone" msprop:Generator_ColumnPropNameInRow="IsDone" msprop:Generator_ColumnPropNameInTable="IsDoneColumn" msprop:Generator_UserColumnName="IsDone" type="xs:boolean" minOccurs="0" />
              <xs:element name="CangDuKien" msprop:Generator_ColumnVarNameInTable="columnCangDuKien" msprop:Generator_ColumnPropNameInRow="CangDuKien" msprop:Generator_ColumnPropNameInTable="CangDuKienColumn" msprop:Generator_UserColumnName="CangDuKien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCurrentOnboard" msprop:Generator_TableClassName="tblCurrentOnboardDataTable" msprop:Generator_TableVarName="tabletblCurrentOnboard" msprop:Generator_TablePropName="tblCurrentOnboard" msprop:Generator_RowDeletingName="tblCurrentOnboardRowDeleting" msprop:Generator_UserTableName="tblCurrentOnboard" msprop:Generator_RowChangingName="tblCurrentOnboardRowChanging" msprop:Generator_RowEvHandlerName="tblCurrentOnboardRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCurrentOnboardRowDeleted" msprop:Generator_RowEvArgName="tblCurrentOnboardRowChangeEvent" msprop:Generator_RowChangedName="tblCurrentOnboardRowChanged" msprop:Generator_RowClassName="tblCurrentOnboardRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Thang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnThang" msprop:Generator_ColumnPropNameInRow="Thang" msprop:Generator_ColumnPropNameInTable="ThangColumn" msprop:Generator_UserColumnName="Thang" type="xs:int" minOccurs="0" />
              <xs:element name="nam" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnam" msprop:Generator_ColumnPropNameInRow="nam" msprop:Generator_ColumnPropNameInTable="namColumn" msprop:Generator_UserColumnName="nam" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cTypeName" msprop:Generator_ColumnVarNameInTable="columncTypeName" msprop:Generator_ColumnPropNameInRow="cTypeName" msprop:Generator_ColumnPropNameInTable="cTypeNameColumn" msprop:Generator_UserColumnName="cTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iRankType" msprop:Generator_ColumnVarNameInTable="columniRankType" msprop:Generator_ColumnPropNameInRow="iRankType" msprop:Generator_ColumnPropNameInTable="iRankTypeColumn" msprop:Generator_UserColumnName="iRankType" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="nRankLevel" msprop:Generator_ColumnVarNameInTable="columnnRankLevel" msprop:Generator_ColumnPropNameInRow="nRankLevel" msprop:Generator_ColumnPropNameInTable="nRankLevelColumn" msprop:Generator_UserColumnName="nRankLevel" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="cFamilyName+ ' ' + cMiddleName + ' ' + cFirstName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cCMT" msprop:Generator_ColumnVarNameInTable="columncCMT" msprop:Generator_ColumnPropNameInRow="cCMT" msprop:Generator_ColumnPropNameInTable="cCMTColumn" msprop:Generator_UserColumnName="cCMT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columncPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="cPlaceOfBirth" msprop:Generator_ColumnPropNameInTable="cPlaceOfBirthColumn" msprop:Generator_UserColumnName="cPlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenPhuongXa" msprop:Generator_ColumnVarNameInTable="columnTenPhuongXa" msprop:Generator_ColumnPropNameInRow="TenPhuongXa" msprop:Generator_ColumnPropNameInTable="TenPhuongXaColumn" msprop:Generator_UserColumnName="TenPhuongXa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenQuanHuyen" msprop:Generator_ColumnVarNameInTable="columnTenQuanHuyen" msprop:Generator_ColumnPropNameInRow="TenQuanHuyen" msprop:Generator_ColumnPropNameInTable="TenQuanHuyenColumn" msprop:Generator_UserColumnName="TenQuanHuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenTinhThanh" msprop:Generator_ColumnVarNameInTable="columnTenTinhThanh" msprop:Generator_ColumnPropNameInRow="TenTinhThanh" msprop:Generator_ColumnPropNameInTable="TenTinhThanhColumn" msprop:Generator_UserColumnName="TenTinhThanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DiaChi" msdata:ReadOnly="true" msdata:Expression="cAddress + ' ' + TenPhuongXa + ' ' + TenQuanHuyen + ' ' + TenTinhThanh" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" msprop:Generator_UserColumnName="DiaChi" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblRank" msprop:Generator_TableClassName="tblRankDataTable" msprop:Generator_TableVarName="tabletblRank" msprop:Generator_TablePropName="tblRank" msprop:Generator_RowDeletingName="tblRankRowDeleting" msprop:Generator_UserTableName="tblRank" msprop:Generator_RowChangingName="tblRankRowChanging" msprop:Generator_RowEvHandlerName="tblRankRowChangeEventHandler" msprop:Generator_RowDeletedName="tblRankRowDeleted" msprop:Generator_RowEvArgName="tblRankRowChangeEvent" msprop:Generator_RowChangedName="tblRankRowChanged" msprop:Generator_RowClassName="tblRankRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" />
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankLevel" msprop:Generator_ColumnVarNameInTable="columnnRankLevel" msprop:Generator_ColumnPropNameInRow="nRankLevel" msprop:Generator_ColumnPropNameInTable="nRankLevelColumn" msprop:Generator_UserColumnName="nRankLevel" type="xs:int" minOccurs="0" />
              <xs:element name="cRankDescription" msprop:Generator_ColumnVarNameInTable="columncRankDescription" msprop:Generator_ColumnPropNameInRow="cRankDescription" msprop:Generator_ColumnPropNameInTable="cRankDescriptionColumn" msprop:Generator_UserColumnName="cRankDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iRankType" msprop:Generator_ColumnVarNameInTable="columniRankType" msprop:Generator_ColumnPropNameInRow="iRankType" msprop:Generator_ColumnPropNameInTable="iRankTypeColumn" msprop:Generator_UserColumnName="iRankType" type="xs:int" minOccurs="0" />
              <xs:element name="BasicMonthlyWages" msprop:Generator_ColumnVarNameInTable="columnBasicMonthlyWages" msprop:Generator_ColumnPropNameInRow="BasicMonthlyWages" msprop:Generator_ColumnPropNameInTable="BasicMonthlyWagesColumn" msprop:Generator_UserColumnName="BasicMonthlyWages" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_A" msprop:Generator_ColumnVarNameInTable="columnOvertime_A" msprop:Generator_ColumnPropNameInRow="Overtime_A" msprop:Generator_ColumnPropNameInTable="Overtime_AColumn" msprop:Generator_UserColumnName="Overtime A" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_B" msprop:Generator_ColumnVarNameInTable="columnOvertime_B" msprop:Generator_ColumnPropNameInRow="Overtime_B" msprop:Generator_ColumnPropNameInTable="Overtime_BColumn" msprop:Generator_UserColumnName="Overtime B" type="xs:double" minOccurs="0" />
              <xs:element name="SubsisAllowence" msprop:Generator_ColumnVarNameInTable="columnSubsisAllowence" msprop:Generator_ColumnPropNameInRow="SubsisAllowence" msprop:Generator_ColumnPropNameInTable="SubsisAllowenceColumn" msprop:Generator_UserColumnName="SubsisAllowence" type="xs:double" minOccurs="0" />
              <xs:element name="Monthly_x0020_leave_x0020_pay" msprop:Generator_ColumnVarNameInTable="columnMonthly_leave_pay" msprop:Generator_ColumnPropNameInRow="Monthly_leave_pay" msprop:Generator_ColumnPropNameInTable="Monthly_leave_payColumn" msprop:Generator_UserColumnName="Monthly leave pay" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblSuggestCrewList" msprop:Generator_TableClassName="tblSuggestCrewListDataTable" msprop:Generator_TableVarName="tabletblSuggestCrewList" msprop:Generator_TablePropName="tblSuggestCrewList" msprop:Generator_RowDeletingName="tblSuggestCrewListRowDeleting" msprop:Generator_UserTableName="tblSuggestCrewList" msprop:Generator_RowChangingName="tblSuggestCrewListRowChanging" msprop:Generator_RowEvHandlerName="tblSuggestCrewListRowChangeEventHandler" msprop:Generator_RowDeletedName="tblSuggestCrewListRowDeleted" msprop:Generator_RowEvArgName="tblSuggestCrewListRowChangeEvent" msprop:Generator_RowChangedName="tblSuggestCrewListRowChanged" msprop:Generator_RowClassName="tblSuggestCrewListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="cFamilyName+ ' ' + cMiddleName + ' ' + cFirstName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cGhiChu" msprop:Generator_ColumnVarNameInTable="columncGhiChu" msprop:Generator_ColumnPropNameInRow="cGhiChu" msprop:Generator_ColumnPropNameInTable="cGhiChuColumn" msprop:Generator_UserColumnName="cGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankLevel" msprop:Generator_ColumnVarNameInTable="columnnRankLevel" msprop:Generator_ColumnPropNameInRow="nRankLevel" msprop:Generator_ColumnPropNameInTable="nRankLevelColumn" msprop:Generator_UserColumnName="nRankLevel" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblAssignment" msprop:Generator_TableClassName="tblAssignmentDataTable" msprop:Generator_TableVarName="tabletblAssignment" msprop:Generator_TablePropName="tblAssignment" msprop:Generator_RowDeletingName="tblAssignmentRowDeleting" msprop:Generator_UserTableName="tblAssignment" msprop:Generator_RowChangingName="tblAssignmentRowChanging" msprop:Generator_RowEvHandlerName="tblAssignmentRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAssignmentRowDeleted" msprop:Generator_RowEvArgName="tblAssignmentRowChangeEvent" msprop:Generator_RowChangedName="tblAssignmentRowChanged" msprop:Generator_RowClassName="tblAssignmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nAssignmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnAssignmentId" msprop:Generator_ColumnPropNameInRow="nAssignmentId" msprop:Generator_ColumnPropNameInTable="nAssignmentIdColumn" msprop:Generator_UserColumnName="nAssignmentId" type="xs:int" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dSanSangLenTau" msprop:Generator_ColumnVarNameInTable="columndSanSangLenTau" msprop:Generator_ColumnPropNameInRow="dSanSangLenTau" msprop:Generator_ColumnPropNameInTable="dSanSangLenTauColumn" msprop:Generator_UserColumnName="dSanSangLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dCatHopDong" msprop:Generator_ColumnVarNameInTable="columndCatHopDong" msprop:Generator_ColumnPropNameInRow="dCatHopDong" msprop:Generator_ColumnPropNameInTable="dCatHopDongColumn" msprop:Generator_UserColumnName="dCatHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dNghiHuu" msprop:Generator_ColumnVarNameInTable="columndNghiHuu" msprop:Generator_ColumnPropNameInRow="dNghiHuu" msprop:Generator_ColumnPropNameInTable="dNghiHuuColumn" msprop:Generator_UserColumnName="dNghiHuu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dKyHopDong" msprop:Generator_ColumnVarNameInTable="columndKyHopDong" msprop:Generator_ColumnPropNameInRow="dKyHopDong" msprop:Generator_ColumnPropNameInTable="dKyHopDongColumn" msprop:Generator_UserColumnName="dKyHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dModified" msprop:Generator_ColumnVarNameInTable="columndModified" msprop:Generator_ColumnPropNameInRow="dModified" msprop:Generator_ColumnPropNameInTable="dModifiedColumn" msprop:Generator_UserColumnName="dModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="cNoiXuong" msprop:Generator_ColumnVarNameInTable="columncNoiXuong" msprop:Generator_ColumnPropNameInRow="cNoiXuong" msprop:Generator_ColumnPropNameInTable="cNoiXuongColumn" msprop:Generator_UserColumnName="cNoiXuong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNoiDi" msprop:Generator_ColumnVarNameInTable="columncNoiDi" msprop:Generator_ColumnPropNameInRow="cNoiDi" msprop:Generator_ColumnPropNameInTable="cNoiDiColumn" msprop:Generator_UserColumnName="cNoiDi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cGhiChu" msprop:Generator_ColumnVarNameInTable="columncGhiChu" msprop:Generator_ColumnPropNameInRow="cGhiChu" msprop:Generator_ColumnPropNameInTable="cGhiChuColumn" msprop:Generator_UserColumnName="cGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblVessel" />
      <xs:field xpath="mstns:nVesselId" />
    </xs:unique>
    <xs:unique name="tblVesselGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblVesselGroup" />
      <xs:field xpath="mstns:nGroupId" />
    </xs:unique>
    <xs:unique name="tblShortPlan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblShortPlan" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="tblKeHoach_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblKeHoach" />
      <xs:field xpath="mstns:Planid" />
    </xs:unique>
    <xs:unique name="tblCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblRank_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblRank" />
      <xs:field xpath="mstns:nRankId" />
    </xs:unique>
    <xs:unique name="tblSuggestCrewList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblSuggestCrewList" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblAssignment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignment" />
      <xs:field xpath="mstns:nAssignmentId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblVessel_tblVesselGroup" msdata:parent="tblVesselGroup" msdata:child="tblVessel" msdata:parentkey="nGroupId" msdata:childkey="nGroupId" msprop:Generator_UserChildTable="tblVessel" msprop:Generator_ChildPropName="GettblVesselRows" msprop:Generator_ParentPropName="tblVesselGroupRow" msprop:Generator_UserRelationName="FK_tblVessel_tblVesselGroup" msprop:Generator_RelationVarName="relationFK_tblVessel_tblVesselGroup" msprop:Generator_UserParentTable="tblVesselGroup" />
      <msdata:Relationship name="FK_tblAssignment_tblVessel" msdata:parent="tblVessel" msdata:child="tblCurrentOnboard" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblCurrentOnboard" msprop:Generator_ChildPropName="GettblCurrentOnboardRows" msprop:Generator_ParentPropName="tblVesselRow" msprop:Generator_UserRelationName="FK_tblAssignment_tblVessel" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblVessel" msprop:Generator_UserParentTable="tblVessel" />
      <msdata:Relationship name="FK_tblAssignment_tblCrew" msdata:parent="tblCrew" msdata:child="tblCurrentOnboard" msdata:parentkey="nCrewId" msdata:childkey="nCrewid" msprop:Generator_UserChildTable="tblCurrentOnboard" msprop:Generator_ChildPropName="GettblCurrentOnboardRows" msprop:Generator_ParentPropName="tblCrewRow" msprop:Generator_UserRelationName="FK_tblAssignment_tblCrew" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblCrew" msprop:Generator_UserParentTable="tblCrew" />
      <msdata:Relationship name="FK_tblAssignment_tblVessel1" msdata:parent="tblVessel" msdata:child="tblSuggestCrewList" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblSuggestCrewList" msprop:Generator_ChildPropName="GettblSuggestCrewListRows" msprop:Generator_ParentPropName="tblVesselRow" msprop:Generator_UserRelationName="FK_tblAssignment_tblVessel1" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblVessel1" msprop:Generator_UserParentTable="tblVessel" />
      <msdata:Relationship name="FK_tblShortPlan_tblKeHoach1" msdata:parent="tblKeHoach" msdata:child="tblShortPlan" msdata:parentkey="Planid" msdata:childkey="PlanID" msprop:Generator_UserChildTable="tblShortPlan" msprop:Generator_ChildPropName="GettblShortPlanRows" msprop:Generator_UserParentTable="tblKeHoach" msprop:Generator_UserRelationName="FK_tblShortPlan_tblKeHoach1" msprop:Generator_RelationVarName="relationFK_tblShortPlan_tblKeHoach1" msprop:Generator_ParentPropName="tblKeHoachRow" />
      <msdata:Relationship name="FK_tblAssignment_tblVessel2" msdata:parent="tblVessel" msdata:child="tblAssignment" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblAssignment" msprop:Generator_ChildPropName="GettblAssignmentRows" msprop:Generator_UserParentTable="tblVessel" msprop:Generator_UserRelationName="FK_tblAssignment_tblVessel2" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblVessel2" msprop:Generator_ParentPropName="tblVesselRow" />
      <msdata:Relationship name="FK_tblAssignment_tblCrew1" msdata:parent="tblCrew" msdata:child="tblAssignment" msdata:parentkey="nCrewId" msdata:childkey="nCrewid" msprop:Generator_UserChildTable="tblAssignment" msprop:Generator_ChildPropName="GettblAssignmentRows" msprop:Generator_ParentPropName="tblCrewRow" msprop:Generator_UserRelationName="FK_tblAssignment_tblCrew1" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblCrew1" msprop:Generator_UserParentTable="tblCrew" />
      <msdata:Relationship name="FK_tblCrew_tblRank" msdata:parent="tblRank" msdata:child="tblCrew" msdata:parentkey="nRankId" msdata:childkey="nRankID" msprop:Generator_UserChildTable="tblCrew" msprop:Generator_ChildPropName="GettblCrewRows" msprop:Generator_ParentPropName="tblRankRow" msprop:Generator_UserRelationName="FK_tblCrew_tblRank" msprop:Generator_RelationVarName="relationFK_tblCrew_tblRank" msprop:Generator_UserParentTable="tblRank" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>